VERSION 5.00
Begin VB.Form DemoSummaryForm 
   BackColor       =   &H00FFFFFF&
   BorderStyle     =   0  'None
   Caption         =   "Form1"
   ClientHeight    =   9000
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   12000
   LinkTopic       =   "Form1"
   ScaleHeight     =   9000
   ScaleWidth      =   12000
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  'Windows Default
   WindowState     =   2  'Maximized
   Begin VB.CommandButton Hold_Button 
      Caption         =   "Hold"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   735
      Left            =   780
      TabIndex        =   5
      Top             =   5580
      Width           =   1935
   End
   Begin VB.CommandButton Back_Button 
      Caption         =   "Back"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   735
      Left            =   780
      TabIndex        =   3
      Top             =   6600
      Width           =   1935
   End
   Begin VB.CommandButton Cancel_Button 
      BackColor       =   &H008080FF&
      Caption         =   "Cancel"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   735
      Left            =   780
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   7620
      Width           =   1935
   End
   Begin VB.CommandButton Next_Button 
      Caption         =   "Continue"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   735
      Left            =   780
      TabIndex        =   0
      Top             =   4560
      Width           =   1935
   End
   Begin VCT.ClientDemoCtrl DEMO 
      Height          =   3855
      Left            =   300
      TabIndex        =   2
      Top             =   240
      Width           =   11415
      _ExtentX        =   20135
      _ExtentY        =   6800
   End
   Begin VB.Label Label4 
      BackColor       =   &H00FFFFFF&
      BackStyle       =   0  'Transparent
      Caption         =   "Go back to change some details previously entered"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   615
      Left            =   2940
      TabIndex        =   8
      Top             =   6720
      Width           =   9015
   End
   Begin VB.Label Label3 
      BackColor       =   &H00FFFFFF&
      BackStyle       =   0  'Transparent
      Caption         =   "Save demographic details and continue to risk assessment"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   675
      Left            =   2940
      TabIndex        =   7
      Top             =   4620
      Width           =   9015
   End
   Begin VB.Label Label1 
      BackColor       =   &H00FFFFFF&
      BackStyle       =   0  'Transparent
      Caption         =   "Save demographic details and return to the main menu"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   615
      Left            =   2940
      TabIndex        =   6
      Top             =   5700
      Width           =   9015
   End
   Begin VB.Label Label2 
      BackColor       =   &H00FFFFFF&
      BackStyle       =   0  'Transparent
      Caption         =   "Return to main menu (demographic details will not be saved)"
      BeginProperty Font 
         Name            =   "Arial Narrow"
         Size            =   20.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   615
      Left            =   2940
      TabIndex        =   4
      Top             =   7740
      Width           =   9075
   End
End
Attribute VB_Name = "DemoSummaryForm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'Demographic summary form
'Back to REASHERE

Private Sub Back_Button_Click()
   REASHERE = ""
   ReasonHereForm.Show
   Unload Me
End Sub

Private Sub Cancel_Button_Click()
   VCTStageForm.Show
   Unload Me
End Sub

Private Sub Form_Load()
   DEMO.UpdateData
End Sub

Private Sub Hold_Button_Click()
  SaveDemoDetails
  VCTStageForm.Show
  Unload Me
End Sub

Private Sub Next_Button_Click()
   SaveDemoDetails
   PrevTestedForm.Show
   Unload Me
End Sub

Private Sub SaveDemoDetails()

   'Save the demographic information in the database
   CnUser.Open ConnectString
   Cmd.CommandText = "UPDATE client SET " & _
                     "COUPTYPE = '" & COUPTYPE & "', " & _
                     "COUNCODE = '" & COUNCODE & "', " & _
                     "AGE = '" & Val(AGE) & "', " & _
                     "RESID = '" & RESCLASS & "', " & _
                     "GROUPSES = '" & GROUPSES & "', " & _
                     "EMPLOYED = '" & EMPLOYED & "', " & _
                     "OCCUPAT = '" & OCCUPAT & "', " & _
                     "EDUEXPE = '" & EDUEXPE & "', " & _
                     "MARSTAT = '" & MARSTAT & "', " & _
                     "MARTYPE = '" & MARTYPE & "', " & _
                     "MARHIST = '" & MARHIST & "', " & _
                     "KNOWUS1 = '" & KNOWUS1 & "', " & _
                     "KNOWUS2 = '" & KNOWUS2 & "', " & _
                     "KNOWUS3 = '" & KNOWUS3 & "', " & _
                     "KNOWUS4 = '" & KNOWUS4 & "', " & _
                     "KNOWUS5 = '" & KNOWUS5 & "', " & _
                     "KNOWUS6 = '" & KNOWUS6 & "', " & _
                     "KNOWUS7 = '" & KNOWUS7 & "', " & _
                     "KNOWUS8 = '" & KNOWUS8 & "', " & _
                     "KNOWUS98 = '" & KNOWUS98 & "', " & _
                     "KNOWUS99 = '" & KNOWUS99 & "', " & _
                     "REFERBY = '" & REFERBY & "', " & _
                     "REASHERE = '" & REASHERE & "' " & _
                     "WHERE VISITID = " & VISITID
   Cmd.CommandType = adCmdText
   Cmd.ActiveConnection = CnUser
   Cmd.Execute
   CnUser.Close

End Sub
